<?php
include('header.php');
include('menu.php');
include("connection/connection.php");
if(isset($_POST['add']))
{
$column_name=$_POST['col'];
$min_val=$_POST['min'];
$max_val=$_POST['max'];
$query="insert into tbl_lookup_range values('','$column_name','$min_val','$max_val')";
$result=mysql_query($query);
}
?>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Add Column</title>
<style type="text/css">
a{text-decoration:none;}
a:link
{
color:#006699;
}
a:visited
{
color:#006699;
}
a:active
{
color:#006699;
}
a:hover
{
color:#000000;
}
</style>
<script language="javascript" type="text/javascript" src="js/validate.js"></script>
</head>
<body>
	<!--<table>
			<tr>
				<td><?php //include('header.php');?></td>
			</tr>
	</table>-->	
	<table width="443">
			<tr>
				<!--<td align="left" width="300"><?php //include('menu.php');?></td>-->
				<td valign="top">
<table border="0" width="300px" id="table21" height="60%" cellspacing="1" style=" padding-top:0px" >
<tr bgcolor="FF9966">
	<td height="29" align="left" valign="top" bgcolor="#FF9966">&nbsp;</td>
	<td bgcolor="#FF9966" align="left" valign="top">&nbsp;</td>
	<td bgcolor="#FF9966" align="left" valign="top" colspan="5">&nbsp;</td>
	<td height="29" align="left" valign="top" bgcolor="#FF9966">&nbsp;</td>
	<td bgcolor="#FF9966" align="left" valign="top">&nbsp;</td>
</tr>
<tr>
	<td bgcolor="#E5E5E5" align="left" valign="top" width="1%">&nbsp;</td>
	<td bgcolor="#E5E5E5" align="left" valign="top" width="5%">
	<!--<img border="0" src="images/my_pag2.jpg">--></td>
	<td bgcolor="#E5E5E5" align="left" width="91%" colspan="5">
	<span lang="en-us">&nbsp;</span><span lang="en-us" style="font-size: 8.5pt"><font face="Verdana" color="#006699"><b>QUALITY CONTROL</b></font></span></td>
	<td bgcolor="#E5E5E5" align="left" valign="top" width="1%">&nbsp;</td>
	<td bgcolor="#E5E5E5" align="left" valign="top" width="5%">
</tr>

<tr>
	<td bgcolor="#E5E5E5" align="left" valign="top" colspan="7">
	<span style="font-size: 3pt" lang="en-us">&nbsp;</span></td>
	<td bgcolor="#E5E5E5" align="left" valign="top" colspan="7"></td>
</tr>
<tr>
	<td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
	<td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
	<td bgcolor="#E5E5E5" align="left" valign="top" colspan="5" bordercolor="#F2F2F2"></td>
	<td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
	<td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
</tr>
<tr>
	<td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
	<td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
	<td align="left" valign="top" colspan="5">
	<table border="0" width="750" id="table22" cellspacing="0" cellpadding="0">
								<!--<tr>
									<td bgcolor="#050505" height="1"></td>
								</tr>!-->
								<tr>
									<td>
										<table border="0" width="100%" id="table23" cellspacing="0" cellpadding="0">
											<tr>
												<td>&nbsp;</td>
											</tr>
											<tr>
												<td align="center">
													<b><a href="qualitylist.php">List</a>&nbsp;|&nbsp;<a href="addcol.php"  style="color:#99CC99">Add</a>&nbsp;|&nbsp;<a href="exceptioncol.php">Range Exception</a></b>
												
											</td>
											</tr>

										
									</table>
								
					
					</td></tr>
					<tr><td><form action="" method="post"><table align="center" border="0" width="300px" id="table21" height="60%" cellspacing="1" style=" padding-top:20px">										<tr><td><font face="Verdana" style="font-size: 8.5pt" color="#000000">Column Name</font></td><td><input type="text" name="col" size="18" style="font-size: 8pt; font-family: Verdana; border:1px solid black;  border-width: 1px"></td></tr>
<tr><td><font face="Verdana" style="font-size: 8.5pt" color="#000000">Min Range</font></td><td><input type="text" name="min" size="18" style="font-size: 8pt; font-family: Verdana; border:1px solid black;  border-width: 1px"></td></tr>
<tr><td><font face="Verdana" style="font-size: 8.5pt" color="#000000">Max Range</font></td><td><input type="text" name="max" size="18" style="font-size: 8pt; font-family: Verdana; border:1px solid black;  border-width: 1px"></td></tr>
<tr><td></td><td><input type="submit" value="Add" name="add" style="border:1px solid #000000; font-size: 8pt; font-family: Verdana; "></td></tr>
</table></form></td>					
				</tr>
				
				
				<tr>
					<td><p align="center"></td>
				</tr>
				<tr>
					<td>&nbsp;</td>
				</tr>
</table>					
</td>
<td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
	<td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
 </tr>

         <tr>
            <td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
								  <td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
								  <td bgcolor="#E5E5E5" align="left" valign="top" colspan="5">
								    <font color="#000000" face="Verdana">
							        <span style="font-size: 8.5pt">
							         
						            </span></font></td>
									 <td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
								  <td bgcolor="#E5E5E5" align="left" valign="top">&nbsp;</td>
									
 </tr>
</table>

</body>
</html>